package com.service.bank.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.client.model.pojo.bank.ArBankcard;
import com.client.model.pojo.bank.ArCardtype;
import com.client.model.pojo.bank.ArElectronic;
import org.apache.ibatis.annotations.Mapper;
import com.client.model.pojo.bank.Record;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import com.github.yulichang.base.MPJBaseMapper;
import com.client.model.system.ArBankcardTypeVo;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;
import com.client.model.vo.deposit.BankVo;
import com.github.yulichang.wrapper.MPJLambdaWrapper;

import java.util.List;
import java.util.Map;

/**
* @author liuwenju
* @description 针对表【ar_bankcard】的数据库操作Mapper
* @createDate 2024-04-01 20:55:27
* @Entity com.service.bank.pojo.ArBankcard
*/
@Mapper
public interface ArBankcardMapper extends MPJBaseMapper<ArBankcard> {





    @Select("SELECT salt FROM ar_bankcard where bank_card=#{bankCard} and moblie=#{moblie}")
    String SelectBankCard(@Param("bankCard") String bankCard,@Param("moblie") String moblie);



    @Select("SELECT pay_password FROM ar_bankcard where bank_card=#{bankCard}")
    String SelectPassword(String bankCard);

    @Select("select cid from ar_bankcard where bank_card=#{bankCard}")
    Long SelectBycCid(String bankCard);

    @Select("select tid from ar_bankcard where bank_card=#{bankCard}")
    Long SelectByTid(String bankCard);


    void collectMoney(@Param("balance") BigDecimal balance, @Param("uid")Long uid);

    ArBankcard findBankCard(String realName);

    List<ArBankcardTypeVo> findBankCards(@Param("bankCard")String bankCard,@Param("realName")String realName);

    Long findUid(String bankCards);

    ArrayList<String> yzBankCards(String realName);

    ArCardtype yzType(String tname);

    void deductMoney(@Param("balance") BigDecimal balance, @Param("bankCard")String bankCard);

    String selectBalance(String bankCard);


    Integer findPassword(@Param("payPassword")String payPassword,@Param("bankCard")String bankCard);

    @Select("select bank_card from ar_bankcard where uid=#{uid}")
    List<ArBankcard> selectLists(Long uid);

    Integer yzTid(String bankCards);
}




